package com.lq.educationsystem.student.mapper;

import com.lq.educationsystem.student.entiy.StudentTb;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Administrator
* @description 针对表【student_tb】的数据库操作Mapper
* @createDate 2024-04-14 16:57:54
* @Entity com.lq.educationsystem.student.entiy.StudentTb
*/
public interface StudentTbMapper {

    int deleteByPrimaryKey(Long id);

    int insert(StudentTb record);

    int insertSelective(StudentTb record);

    StudentTb selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(StudentTb record);

    int updateByPrimaryKey(StudentTb record);

    List<StudentTb> queryList(@Param("start") int start,@Param("pageSize") Integer pageSize,@Param("studentTb") StudentTb studentTb);

    //通过用户账号查询用户信息
    StudentTb queryByAccount(@Param("studentAccount") String studentAccount);

    /**
     * 查询总数
     * @param studentTb
     * @return
     */
    int queryCount(@Param("studentTb") StudentTb studentTb);

    /**
     * 通过id批量查询
     * @param collectStudentIdList
     * @return
     */

    List<StudentTb> queryBatch(@Param("collectStudentIdList") List<Integer> collectStudentIdList);

    /**
     * 通过学生id集合查询学生信息
     * @param studentIdList
     * @return
     */
    List<StudentTb> queryBatchStudentInfoByStudentIdList(@Param("studentIdList") List<Integer> studentIdList);
}
